﻿

--分类属性表  Property：

CREATE TABLE [dbo].[T_ClassProperty](
	[F_AutoId] [int] IDENTITY(1,1) NOT NULL,--辅助自动ID(预留)
	[F_ClsProId] Int Default(0) NOT NULL,--主键
	[F_ClsId] Int Default(0) NOT NULL,--关联外键(分类ID)
	[F_DisplayName] varchar(50) NOT NULL,--(扩展属性)显示名称(比如：品牌，内存大小，颜色之类)
	[F_FieldName] varchar(50) NOT NULL,--(扩展属性)字段名称(比如：Brand,Memoery,Color之类)
	[F_ValueType] varchar(50) NOT NULL,--字段类型(比如：字符串，整数，日期之类)
	[F_ValueLength] int Default(0) NOT NULL,--属性值长度(比如:50)
	[F_InputType] varchar(50) NOT NULL,--输入类型(比如：文本框，文本域，下拉框，复选框之类)
	[F_DefaultValue] varchar(500) NOT NULL,--默认值
	[F_IsRequired] tinyint Default(0) NOT NULL,--是否必须填写
	[F_IsShow] tinyint Default(0) NOT NULL,--显否显示
	[F_Orders] int Default(0) NOT NULL,--排序号
	CONSTRAINT [PK_T_ClassProperty] PRIMARY KEY CLUSTERED
(
	[F_ClsAppId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_MC_T_ClassAppendValueValue_F_ClsAppId] ON [dbo].[T_ClassAppendValueValue]
(
	[F_ClsId] DESC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]
GO